package com.itheima.dao;

import com.itheima.domian.Member;
import com.itheima.domian.Traveller;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ITravellersDao {

    //    根据ID查询
    @Select("select * from Traveller where id in(select TRAVELLERID  from  ORDER_TRAVELLER where orderid = #{orderId})")
    public List<Traveller> findByOrdersId(String orderId) throws Exception;

}
